How to: Export an Access table or query to another file format.
Solution:
Use the 'Save As/Export...' command in the 'File' menu, select the desired file type, specify a name and a location, and click 'Export', then follow any instructions displayed.
1) Open the desired database.
2) If the Database window is not active, activate the Database window.
3) In the Database window, click the appropriate tab.
4) Select the object to export from the list.
NOTE: To export a portion of a table or query, open the table or query in Datasheet view and drag the row selector to select the portion before continuing.
Row Selector
5) Select the 'File' menu and select 'Save As/Export...'. (The Save As... dialog box appears.)
6) Select the 'To an external File or Database' radio button.
the To an external File or Database radio button
7) Click 'OK'. (The Save <object> <object name> In dialog box appears, where <object> is the selected object type and <object name> is the name of the selected object.)
8) Select the desired file type from the 'Save as type' drop-down list.
Selecting the desired file type
9) Select the drive where the new file is to be stored from the 'Save in' drop-down list.
10) Select the specific folder to store the file.
NOTE: If the file is to be stored in a subfolder, continue selecting folders until the desired folder is displayed in the 'Save in' drop-down list box.
11) Do one of the following:
a) Type a name for the file in the 'File name' drop-down list box.
b) Accept the name suggested by Access.
12) Click 'Export'.
Exporting the table or query
13) If a wizard appears, follow the instructions displayed by the wizard.